﻿<%@ Page Title="" Language="C#" MasterPageFile="~/Boss/BossMasterPage.master" AutoEventWireup="true" CodeFile="StaffList.aspx.cs" Inherits="Boss_StaffList" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
    <div style="margin: 0px auto; width: 100%; text-align:center;background-color:#f3f9eb;padding-bottom:100px" >
        <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="Sno" DataSourceID="SqlDataSource1" OnSelectedIndexChanged="GridView1_SelectedIndexChanged">
            <Columns>
                <asp:CommandField SelectText="编辑" ShowSelectButton="True" />
                <asp:BoundField DataField="Sno" HeaderText="职工编号" ReadOnly="True" SortExpression="Sno" />
                <asp:BoundField DataField="Sname" HeaderText="职工名称" SortExpression="Sname" />
                <asp:BoundField DataField="Sphone" HeaderText="联系方式" SortExpression="Sphone" />
                <asp:CheckBoxField DataField="Ssex" HeaderText="性别" SortExpression="Ssex" />
                <asp:BoundField DataField="Sbirth" HeaderText="出生日期" SortExpression="Sbirth" />
                <asp:BoundField DataField="Rno" HeaderText="所属店铺号" SortExpression="Rno" />
                <asp:BoundField DataField="Sdute" HeaderText="职位" SortExpression="Sdute" />
            </Columns>
        </asp:GridView>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="Data Source=SUBAI-WORKSTATI;Initial Catalog=Restaurant;User ID=BOSS;Password=ss" ProviderName="System.Data.SqlClient" SelectCommand="SELECT [Sno], [Sname], [Sphone], [Ssex], [Sbirth], [Rno], [Sdute] FROM [Boss_Staff]"></asp:SqlDataSource>
    </div>
</asp:Content>

